-- Write your code here:
SELECT id, identifier, description FROM parts ORDER BY identifier DESC, required DESC, description ASC;